﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="fpyj.aspx.cs" Inherits="fpyj" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <ul>
            <asp:Repeater ID="Repeater1" runat="server" DataSourceID="ReportTypeDataSource">
                <ItemTemplate>
                    <li><a href='fpyj.aspx?Rtype=<%# Eval("id")%>'>
                        <%# Eval("type")%>
                    </a></li>
                </ItemTemplate>
            </asp:Repeater>
        </ul>
        <asp:SqlDataSource ID="ReportTypeDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:decheatConnectionString %>"
            SelectCommand="SELECT [id], [type] FROM [Dyh_type]"></asp:SqlDataSource>
        topN </br>
        <ul>
            <asp:Repeater ID="Repeater2" runat="server" DataSourceID="ReportTypeTopNDataSource">
                <ItemTemplate>
                    <a href="fpyj.aspx?Rtype=<%# Eval("type")%>&RId=<%# Eval("id")%>">
                        <%# Eval("object")%>
                    </a>
                    <br />
                </ItemTemplate>
            </asp:Repeater>
        </ul>
        <asp:SqlDataSource ID="ReportTypeTopNDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:decheatConnectionString %>"
            SelectCommand="SELECT top 3 [id],[type],[object], [S_times] FROM [Dyh_baseDB] WHERE (([Delete_flag] = @Delete_flag) AND ([type] = @type)) ORDER BY [R_times] DESC">
            <SelectParameters>
                <asp:Parameter DefaultValue="false" Name="Delete_flag" Type="Boolean" />
                <asp:QueryStringParameter DefaultValue="0" Name="type" QueryStringField="Rtype" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
        <br />
        <ul>
            <asp:Repeater ID="Repeater3" runat="server" DataSourceID="OtherReportDataSource">
                <ItemTemplate>
                <li><%# Eval("IP_from")%>说： <%# Eval("R_type")%><br />具体内容<%# Eval("R_content")%></li>
                </ItemTemplate>
            </asp:Repeater>
        </ul>
        <asp:SqlDataSource ID="OtherReportDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:decheatConnectionString %>"
            SelectCommand="SELECT top 3 [R_content], [R_type], [IP_from] FROM [Dyh_report] WHERE ([seqID] = @seqID) ORDER BY [time]">
            <SelectParameters>
                <asp:QueryStringParameter DefaultValue="0" Name="seqID" QueryStringField="RId" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>


        <br />
        <br />

          <ul>
            <asp:Repeater ID="TongjiRepeater" runat="server" DataSourceID="TongjiDataSource">
                <ItemTemplate>
                <li><%# Eval("type")%>举报了： <%# Eval("couttimes")%>次<br /></li>
                </ItemTemplate>
            </asp:Repeater>
        </ul>
      
        <asp:SqlDataSource ID="TongjiDataSource" runat="server" 
            ConnectionString="<%$ ConnectionStrings:decheatConnectionString %>" 
            SelectCommand="tongjiByPTypeId" SelectCommandType="StoredProcedure">
            <SelectParameters>
                <asp:QueryStringParameter DefaultValue="0" Name="PTypeId" 
                    QueryStringField="Rtype" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>

    </div>
    

    </form>
</body>
</html>
